SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 63556: Applying a hot fix for SAS® Anti-Money Laundering results in an error during the data definition language (DDL) application

DetailsHotfixAboutRate It

You might encounter an error that is similar to the following after you apply Hot Fix A5T005 for SAS® Anti-Money Laundering 7.1:

REORG TABLE FCFKC.FSK_ALERTED_ENTITY
The command was processed as an SQL statement because it was not a valid Command Line Processor command.
During SQL processing it returned:
SQL0104N  An unexpected token "END-OF-STATEMENT" was found following "C.FSK_ALERTED_ENTITY".
Expected tokens may include: "JOIN <joined_table>". 
SQLSTATE=42601

This issue occurs if IBM DB2 is your solution database provider.

To work around this issue, you can do either of the following:

  • Apply Hot Fix A5T007 (or a later hot fix).
  • Replace line 32 of the db2_7.1_to_7.1HF4_ddl.sql file with the following text:
       REORG TABLE FCFKC.FSK_ALERTED_ENTITY;

Click the Hot Fix tab in this note to access the hot fix for this issue.



Operating System and Release Information

Product FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS Anti-Money LaunderingMicrosoft® Windows® for x647.17.19.4 TS1M6
64-bit Enabled AIX7.17.19.4 TS1M6
64-bit Enabled Solaris7.17.19.4 TS1M6
Linux for x647.17.19.4 TS1M6
* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.